Summing

B

Ben

Hi
I'm a bit new to excel. I was just wondering if it is possible to sum an
entire column conditionally on an adjacent column.

This is what I have, but excel doesn't seem to like it
=SUMPRODUCT((ColumnTitle="NeedsSumming")*(G:G))

Thanks in advance
Ben
 
R

Roger Govier

Hi Ben

Sumproduct will not take a whole column as its range
Try something like
=SUMPRODUCT(--(A2:A10000="Needs Summing")*G2:G10000)
 
B

Ben

OK thanks.

Roger Govier said:
Hi Ben

Sumproduct will not take a whole column as its range
Try something like
=SUMPRODUCT(--(A2:A10000="Needs Summing")*G2:G10000)
Click to expand...
 
Top