Sumif

  • Thread starter Thread starter Angel160
  • Start date Start date
A

Angel160

If I use a SUMIF function, is it possible to compare different range
that have different criteria? If not, does any one know a way that
can do this?

Thank you
 
Unless I have missed something, I would have thought you could nest a
many SUMIF statements within a normal Sum statement, such as,

=SUM(SUMIF(A4:A8,">4"),SUMIF(B3:B8,">3")
 
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

SUMIFS error 1
Using SUMIF and AND functions simultaneously 3
Sumif & Sort 3
SUMIF & OR 6
SUMIFS using an "Or" condition? 13
SUMIF and INDIRECT reference to tab in other workbook 3
Combine Sumif 1
SUMIF, use List as a Range 2

Back
Top