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)
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed 0
Search for a sum! 4
Changing cell color with a formula? 3
Sumif all Null Values 8
problem with conditional sum in excel 2003 3
Excel 97 - Sum filtered list with creiteria 1
CONDITIONAL SUM FOR MULTIPLE CRITERIA IN SINGLE RANGE 1
=SUMPRODUCT((Data1!$B$1:$B$500="March")*(Data1!$C$1:$C$500="New 3

Back
Top