Add up a Dynamic Range with 2 Variables

J

John

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,Basic))))


Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add up a Dynamic Range with 2 Variables 2
Multiple Columns in Sum Range using SUMIFS 1
Looking for a way to Force Successor Task to next workday IF 'x' amount of time left in workday 0
using =COUNTIF() in a variable range on a different worksheet? 4
SUMIF() to add cells in non-contiguous ranges? (Excel 2003) 4
Please HELP...nervous wreck time calculation 3
Formula for dynamic data organiztion 0
Problem with Formula 15

Top