BCF1MTD1322022 FIN YEAR331/03/202145SALES#VALUE!F1F1=HLOOKUP($F$3,TB!$AO$3:$BX$296,294,FALSE)F3F3=D3-365F5F5=SUMIFS(TB!D4:BX292,TB!B4:B292,'Current vs Prev Detailed'!B5,TB!D296:BX296,'Current vs Prev Detailed'!F1)...
Trying to do a relatively simple SUMIFS formula, but getting a #VALUE ! error. I want to sum the weeks where YTD is on row 1:
<tbody>
YTD
YTD
Week 1
Week 2
Week 3
Total
All COLORS
3827
3666
3997
11490
Total BLUE
0
0
6
6
Total GREEN
50
65
22
138
Total YELLOW
71
48
48
167
Total...
Hi Guys,
I have used SUMIFS many times before without any issues but cant seem to understand why it is errors out (#VALUE! error) in the following formula. All my ranges are the same size, Column K is TEXT format although not sure why this would have any impact. Column O is also in TEXT...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.