sumif

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sue - 21 May 2008 21:28 GMT

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.

Reply to this Message

Bob Phillips - 21 May 2008 21:34 GMT

=SUMIF(Sheet1!A:A,"ABC",Sheet1!D:D)+SUMIF(Sheet2!A:A,"ABC",Sheet2!D:D)+...

Signature

---
HTH

Bob

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

> Have a formula that I am trying to create. The answer is probably easy;
> but
[quoted text clipped - 7 lines]
>
> Any help would be creatly appreciated.

Reply to this Message

Bob Phillips - 21 May 2008 21:41 GMT

or

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

Signature

---
HTH

Bob

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

> Have a formula that I am trying to create. The answer is probably easy;
> but
[quoted text clipped - 7 lines]
>
> Any help would be creatly appreciated.

Reply to this Message

Bob Phillips - 21 May 2008 21:42 GMT

I mean

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

Signature

---
HTH

Bob

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

> Have a formula that I am trying to create. The answer is probably easy;
> but
[quoted text clipped - 7 lines]
>
> Any help would be creatly appreciated.

Reply to this Message