[Answered] SUMIF Based on Date and Text

This thread is solved

Paul

New member
Hello!
My spreadsheet shows (in columns) each month and below it has Actuals numbers and Budget numbers. 1710450685205.png (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.
 

Online statistics

Members online
1
Guests online
18
Total visitors
19

Forum statistics

Threads
311
Messages
1,378
Members
568
Latest member
WilliamHon
Top