[Answered] SUMIF Based on Date and Text

[Paul]

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!

 

[shamimarita]

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.