Summing

  • Thread starter Thread starter Ben
  • Start date Start date
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
 
Hi Ben

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