sumif - QUESTION
Hi there,
I know this is easy but I just can't remember how to do this.
Working on one sheet. One column is a type, the other column is a value. I want to sum the value of each type. Here's a snapshot and thank you for your help.
Thank you,
Rebecca
Answers
-
Hi @Rebecca Panaccione ,
You'll need a separate formula for each type. The formula would be:
=SUMIF([type]:[type], "Sick Leave", [value]:[value])
Substitute your column names for my type and value placeholders.
Work?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Hi Mark,
It's still unparseable. I probably didn't provide enough information. My sheet is pretty primitive, so if you know of a better method, I would appreciate that. One sheet per person. I'm tracking leave for an entire academic year. My thought was to drag the formula down the column as leave is added. Or I can just formulate the entire column. I'm wondering if I should separate the type into columns and just keep running totals. But if you can help me with the formula above, it may work better with the sheet overall. An @call or @row formula?
What do you think?
Rebecca
-
Hi Rebecca,
You can do it this way but you have to limit the ranges because your count formulas are in the same column.
Try:
=SUMIF([type of leave]1:[type of leave]22, "Sick Leave", [days]1:[days]22)
You'll need to adjust the 1 and 22 to reflect the first and last rows with data, or you can end with the row before your "totals".
Work?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!