Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Add up a Dynamic Range with 2 Variables
I am trying to add up a Dynamic column if 2 variables are valid. I've tried
the folowing formula with only 1 variable and it works great =(SUMIF(StaffType,"="&K13,Basic)) K13=Hourly and "Basic" is a range name set for total minutes worked However what I want to do is add up Basic for only Hourly staff AND a specific day. I have this day variable in AH9 and the Dates are in a Range name called "DailyDate". I've tried the following but there is an "too few arguements" error in the formula which I can't work out. Is it possible? =(SUMIF(AND(StaffType,"="&K13,DailyDate,"="&AH9,Ba sic)))) Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passing a range name as an argument to the Index Function | Excel Discussion (Misc queries) | |||
Add up a Dynamic Range with 2 Variables | Excel Worksheet Functions | |||
Dynamic Range Problem | Excel Discussion (Misc queries) | |||
Add a Dynamic Range with 2 Conditions Q | Excel Worksheet Functions | |||
named range refers to: in a chart | Excel Discussion (Misc queries) |