Hi everyone,
I have attached a spreadsheet to exemplify my query. I wish to add up the number of parts for specific scenarios, eg.
Add up the number of parts in column B when the Batch (column C) is 3 and Status (column D) is either Pending or Dispatched.
I've been trying to nest sumproduct with sumif functions, to no avail. Can anyone help please?
Cheers, AV
Try this.....
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Hi
According your sample(3 options in columnD), this does the job.
Formula:
Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thanks very much
Here's another one.
Use cells to hold the criteria.
F2 = 3
G2 = Pending
H2 = Dispatched
Then, this formula:
=SUMPRODUCT(SUMIFS(B:B,C:C,F2,D:D,G2:H2))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks