sumif

  • Thread starter Thread starter Sue
  • Start date Start date
S

Sue

Have a formula that I am trying to create. The answer is probably easy; but
I seem to be missing something.

Would like to sum based on client sales. So if column A has ABC company, I
would like to total the sales in column D.

I would like to cover 12 worksheets and total on number 13.

Any help would be creatly appreciated.
 
=SUMIF(Sheet1!A:A,"ABC",Sheet1!D:D)+SUMIF(Sheet2!A:A,"ABC",Sheet2!D:D)+...

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
or

=SUMPRODUCT(SUMIF(INDIRECT("Sheet"&ROW(INDIRECT("1:13"))&"!A2:A20"),"ABC",INDIRECT("Sheet"&ROW(INDIRECT("1:13"))&"!D2:D20")))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
I mean

=SUMPRODUCT(SUMIF(INDIRECT("Sheet"&ROW(INDIRECT("1:12"))&"!A2:A20"),"ABC",INDIRECT("Sheet"&ROW(INDIRECT("1:12"))&"!D2:D20")))

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top