Trying to merge these two formulas to get specific results
=SUMPRODUCT(--(WEEKDAY($B2:$B1000,2)=1),$G2:$G1000) this gives me total for a day
=SUMIF($A:$A,"OPSA",$G:$G) this gives me total per dept(OPSA)
i need total per dept for each day
Trying to merge these two formulas to get specific results
=SUMPRODUCT(--(WEEKDAY($B2:$B1000,2)=1),$G2:$G1000) this gives me total for a day
=SUMIF($A:$A,"OPSA",$G:$G) this gives me total per dept(OPSA)
i need total per dept for each day
Last edited by jonahbosworth; 04-16-2013 at 01:09 PM.
Assuming you have the department name in K1
=SUMPRODUCT(--(WEEKDAY($B2:$B1000,2)=1),--($A2:$A1000= $K$1), $G2:$G1000)
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
try
=SUMPRODUCT((WEEKDAY($B2:$B1000;2)=1)*(A2:A1000="OPSA")*($G2:$G1000))
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.
Chem, gives my a false statement, and Fotis, gives me an value error
Why? ..................
Havent a clue, tryin go figure that out now
Did you put something in K1?
=SUMPRODUCT(--(WEEKDAY($B2:$B1000,2)=1),--($A2:$A1000= $K$1), $G2:$G1000)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks