How do I use sumifs -

W

wantfit

I want to use sumifs to find the results. For range A1:A100, If value in
column A = column C (a1=c1, or a2=c2,etc), then sum up Range A1:A100. How do
I do that?

Thanks
 

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

SUMIFS, one criteria range, multiple criteria 3
SumIF 4
sumifs 1
sumifs multiple columns help 1
sumifs/sumproduct 8
Use dynamic column reference without R1C1 3
Like SUMIFS, but for multiplication??? 3
Convert/rewrite SUMIFS formula to work in Excel 97 3

Top