willow1985
Well-known Member
- Joined
- Jul 24, 2019
- Messages
- 929
- Office Version
- 365
- Platform
- Windows
Hello,
I do not know what is wrong with the below formula - receiving a #Value error:
=SUMIFS('WO Report'!F2:F1000000, $B$14,'WO Report'!V2:V1000000,$B$12,'WO Report'!S2:S1000000)
Let me break the information down for you, I have 2 tabs: Tables and WO Report. The formula is in the tab called Tables.
[TABLE="width: 373"]
<tbody>[TR]
[TD]WO Report[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Tables[/TD]
[/TR]
[TR]
[TD]Column F[/TD]
[TD]Column V[/TD]
[TD]Column S[/TD]
[TD][/TD]
[TD]Cell B12 Current Year[/TD]
[/TR]
[TR]
[TD]Invoice amount[/TD]
[TD]Month [/TD]
[TD]Year[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]250[/TD]
[TD]September[/TD]
[TD]2019[/TD]
[TD][/TD]
[TD]Cell B14 Current Month[/TD]
[/TR]
[TR]
[TD]250[/TD]
[TD]August[/TD]
[TD]2019[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]50[/TD]
[TD]September[/TD]
[TD]2019[/TD]
[TD][/TD]
[TD]Formula[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]August[/TD]
[TD]2018[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 373"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Column F in WO Report is invoice amounts
Cell B14 is the current month name, aka: September - (I have it reference like this so we can modify the month we want to look at)
Column V in the WO Report has a formula to determine the Month name
Cell B12 is the current year
Column S in the WO Report has a formula that calculates the current year for the data on that sheet.
What I am looking to do is SUM all of the invoice amounts in Column F if the Month and year matches what is listed in B12 & B14 on the Tables tab. No idea why I am getting a #Value error.
Note: The invoice amount and month columns could have blanks
Any help would be greatly appreciated
Thank you
Carla
I do not know what is wrong with the below formula - receiving a #Value error:
=SUMIFS('WO Report'!F2:F1000000, $B$14,'WO Report'!V2:V1000000,$B$12,'WO Report'!S2:S1000000)
Let me break the information down for you, I have 2 tabs: Tables and WO Report. The formula is in the tab called Tables.
[TABLE="width: 373"]
<tbody>[TR]
[TD]WO Report[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Tables[/TD]
[/TR]
[TR]
[TD]Column F[/TD]
[TD]Column V[/TD]
[TD]Column S[/TD]
[TD][/TD]
[TD]Cell B12 Current Year[/TD]
[/TR]
[TR]
[TD]Invoice amount[/TD]
[TD]Month [/TD]
[TD]Year[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]250[/TD]
[TD]September[/TD]
[TD]2019[/TD]
[TD][/TD]
[TD]Cell B14 Current Month[/TD]
[/TR]
[TR]
[TD]250[/TD]
[TD]August[/TD]
[TD]2019[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]50[/TD]
[TD]September[/TD]
[TD]2019[/TD]
[TD][/TD]
[TD]Formula[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]August[/TD]
[TD]2018[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 373"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Column F in WO Report is invoice amounts
Cell B14 is the current month name, aka: September - (I have it reference like this so we can modify the month we want to look at)
Column V in the WO Report has a formula to determine the Month name
Cell B12 is the current year
Column S in the WO Report has a formula that calculates the current year for the data on that sheet.
What I am looking to do is SUM all of the invoice amounts in Column F if the Month and year matches what is listed in B12 & B14 on the Tables tab. No idea why I am getting a #Value error.
Note: The invoice amount and month columns could have blanks
Any help would be greatly appreciated
Thank you
Carla
Last edited: