SUMIF

V

vivek

I want to use a cell reference as the criteria argument of SUMIF.
for eg.: SUMIF(A7:A206,A2,C7:C206)
So that cells from A7 through A206 are compared to A2
(which is a drop-down list) and the total is displayed.

How can I do this?

Vivek
 
V

vivek

Oops! I never used SUMIF so I typed it as in the Help file: "A2"

TY :)

Vivek

Leo Heuser said:
You *have* done it :)

What happens, when you enter
=SUMIF(A7:A206,A2,C7:C206)

It *should* work right away.
Click to expand...

<snip>
 

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

SUMIF 8
"IF" help 3
How to compare a cell containing a date in sumif criteria 5
Sumif does not work 2
sumif issues 1
Sumif with criteria help 3
Help with SUMIF & AND function 2
sumif wildcard criteria 1

Top