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 "DalyDate". 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

If the ranges are equally sized (vectors)...

=SUMPRODUCT(--(StaffType=K13),--(DailyDate=AH9),Basic)

John wrote:
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 "DalyDate". 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

Thanks, Bob and Aladin, works great


"Aladin Akyurek" wrote in message
...
If the ranges are equally sized (vectors)...

=SUMPRODUCT(--(StaffType=K13),--(DailyDate=AH9),Basic)

John wrote:
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 "DalyDate". 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