sum cells
 

Hi,
I need a way to count the cells in column B in relation to column A.
Both columns have numbers.
I found this in the help file and adapted it
=SUM(IF(G3:G99="F",IF(P3:P99=1,1,0)))
but it will not work with 2 sets of numbers :(
Is there a way to do this within the spread sheet ?
Thanks
Michael

sum cells
 

try this
=SUMproduct((G3:G99="F")*(P3:P99=1))


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Michael" wrote in message
...
Hi,
I need a way to count the cells in column B in relation to column A.
Both columns have numbers.
I found this in the help file and adapted it
=SUM(IF(G3:G99="F",IF(P3:P99=1,1,0)))
but it will not work with 2 sets of numbers :(
Is there a way to do this within the spread sheet ?
Thanks
Michael