SUMIFS incorrect argument set
Hello, im trying to sum monthly revenue in a metrics sheet off of a source sheet based off of year, month, and concept. im getting incorrect argument set based off of the formula. does the logic below make sense? The Period and Year are a drop down list cell in the source sheet.
=SUMIFS({BBI - Monthly Billed}, {BC}, [Primary Column]@row, {Period - Source}, MONTH(@cell )=[Column2]3, {Source Year}, YEAR(@cell )=$[Primary Column]$1)
Answers
-
Try this:
=SUMIFS({BBI - Monthly Billed}, {BC}, [Primary Column]@row, {Period - Source}, MONTH([Column2]3), {Source Year}, YEAR($[Primary Column]$1)).
Michelle Choate
michelle.choate@outlook.com
Always happy to walk through any project you need help with!
-
Unfortunately that did not work :(
-
What is the error that you are getting?
Michelle Choate
michelle.choate@outlook.com
Always happy to walk through any project you need help with!
-
im getting error #incorrectargumentset.
-
This is now giving me an answer of 0
=SUMIFS({BBI - Monthly Billed}, {BC}, [Primary Column]@row, {Period - Source}, MONTH([Column2]3), {Source Year}, YEAR($[Primary Column]$1))
The reference {BBI-Monthly Billed} is just one cell from my source sheet im referencing. not sure if thats the problem. However, if i were to select a range of cells or column it gives me an incorrectargument set error.
-
Here is a some screen shots to help.
below is my metric sheet im using the sumif equation,.
the below is the reference sheet. The year/Period filter is a drop down and i can filter out by year or month in the reference sheet. i was hoping to be able to show a monthly billed number based off of period/year in my metrics sheet above. im not sure else how to show billed by month all on one sheet.
-
That is the problem. Currently your SUMIFS formula is looking at just one cell to sum.
You will need to set up your sheet a little bit differently to get the information you are looking for. I can show you on a quick zoom, but it is hard for me to put into words to type. Or someone else can give it a go trying to explain what is needed.
Michelle Choate
michelle.choate@outlook.com
Always happy to walk through any project you need help with!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!