Excel (If Statement)

June 17, 2009 at 05:45:54
Specs: Windows Vista, 3 gig
How would I construct a statement in Excel to look in three cells e.g.(A1,A2,A3), for a value greater than 7 and add 1 to cell (A4) for each value found that is greater than 7?

Thanks,

george_floto@earthlink.net


See More: Excel (If Statement)

Report •


#1
June 17, 2009 at 07:31:29
Try:

=COUNTIF(A1:A3,">7")

MIKE

http://www.skeptic.com/


Report •

#2
June 17, 2009 at 12:08:32
Thanks, Mike

Report •

#3
June 17, 2009 at 14:43:53
Glad I could help.

MIKE

http://www.skeptic.com/


Report •

Related Solutions


Ask Question