add only figures in red colour in excel 2007

  franelli 09:02 05 Oct 2008

how can i add up figures in excel 2007 that are in the red colour only. i make a list of figures in a column and some i highlight in red colour but i only want to add the red figures

  VoG II 09:52 05 Oct 2008

This should help click here

  franelli 11:13 05 Oct 2008

thanks VoG..all done

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

WPA2 hack: How secure is your Wi-Fi?

Add Depth Of Field to a photo using Tilt Shift Blur in Photoshop

iPhone tips & tricks

Comment afficher des fichiers cachés sur Mac ?