Add to a total IF a specific word is present in coloumn C.

**milesy2000** · 11-25-2010, 09:17 AM

Hello

I have a simple spreadsheet for recording orders that we make at our company and a separate tab for each small department.

It's set up like so:

Please Login or Register  to view this content.

What I can't seem to figure out is what formula to put in C1 to only add (C4:C2000) with the word "Agency" being present for that row in coloumn B and likewise for 'Stationery' in Cell F1.

Please can someone help me with this, I'm sure it must be simple.

I just want to record current totals based on what type of order is made.

Many Thanks

**arthurbr** · 11-25-2010, 09:21 AM

Your question is not clear. Do you want to
sum col C where B="agency" and "stationery" in F?
sum col C where B="agency"
sum col C where F= "stationery" ?

**Richard Buttrey** · 11-25-2010, 09:23 AM

Hi,

=SUMIF(B4:B2000,"Agency",C4:C2000)

Rgds

**arthurbr** · 11-25-2010, 09:24 AM

=sumproduct((b4:b2000="agency")*(f4:f2000="stationery")*c4:c200) in the first case

For the others =sumif(b4:b2000,"agency",c4:c2000) and likewise

**milesy2000** · 11-25-2010, 09:30 AM

Many Thanks to both of you!

This is the one I was after:

=SUMIF(B4:B2000,"Agency",C4:C2000)

Cheers

Add to a total IF a specific word is present in coloumn C.

LinkBack

Thread Tools

Rate This Thread

Display

Add to a total IF a specific word is present in coloumn C.

Re: Add to a total IF a specific word is present in coloumn C.

Re: Add to a total IF a specific word is present in coloumn C.

Re: Add to a total IF a specific word is present in coloumn C.

Re: Add to a total IF a specific word is present in coloumn C.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions