Sumif Help Please

J

John

Hello All,

I am trying to use the sum if function to some from a range of cells as follows:

If cell A1 equals any Cell in range B3:Y6
And
If Cell B3 equals any cell in range N7:Y20

What is the easiest way to express this.

Thanks
 
F

Frank Kabel

Hi
do you only want to compare these two cells with the range or what should
happen exactly?
 
B

Bob Phillips

=SUMIF(B3:Y6,A1)+SUMIF(N7:Y20,B3)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

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 with SUMIFS 2
SUMIF returning incorrect answer 2
Excel - Wich Function should I use? 1
RELATIVE REFERENCE WHEN MATCHING 2 PRODUCTS 4
Inequalities Function 3
SUMIF data that falls within a range 3
SUMIF with criteria "<>" & "=" 4
Pasting a cell into bookmarked table from excel vba 1

Top