# [Answered]SUMIF Based on Date and Text

#### Paul

##### New member
Hello!
My spreadsheet shows (in columns) each month and below it has Actuals numbers and Budget numbers. (there is a column between each month) There is the Year to Date Totals at the end. I need to sum all of the Actual numbers for the YTD. This is the formula I am using =SUMIF\$B\$4:\$AJ\$4,"<"&\$B\$3,B6:AJ6) which works fine but it is giving me the total for Actual and Budget together. How can I separate them?

Thanks!

Hello!
My spreadsheet shows (in columns) each month and below it has Actuals numbers and Budget numbers. View attachment 1295 (there is a column between each month) There is the Year to Date Totals at the end. I need to sum all of the Actual numbers for the YTD. This is the formula I am using =SUMIF\$B\$4:\$AJ\$4,"<"&\$B\$3,B6:AJ6) which works fine but it is giving me the total for Actual and Budget together. How can I separate them?

Thanks!
Hello Paul,
Please share your sample workbook. You can use dummy data. Otherwise, it won't be possible to understand the value of your mentioned ranges.

Members online
1
Guests online
18
Total visitors
19