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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks