beatrix
miserable fan
- Joined
- Feb 3, 2012
- Messages
- 852
- Reaction score
- 51
thanks beatrix!
sounds like it worked. thanks for the pos.
thanks beatrix!
Bump
I have a spreadsheet that lists all costs from various medical providers, some of which are related to the accident and some of which aren't. In C5:C27 we have the costs, and in J5:J27 we have a True/False listing for whether or not they're related. I used a SumIf function to get the related total, but what I want to be able to do now is to filter the data by provider and get the related subtotal for each one. Looked online but haven't been able to get any of those solutions to work for me. Suggestions?
Thanks in advance.
Do you need to filter, or do you just want a list by provider? You can use SUMIFS (basically sumif but with multiple criteria).
ETA: So you would list each supplier, using column C as the sum range, and criteria 1 is column J is True, and criteria 2 is that the provider is equal to whatever provider you're looking for. If you need help you can list all the related cells so I can show you how the formula would look.
Do you need to filter, or do you just want a list by provider? You can use SUMIFS (basically sumif but with multiple criteria).
ETA: So you would list each supplier, using column C as the sum range, and criteria 1 is column J is True, and criteria 2 is that the provider is equal to whatever provider you're looking for. If you need help you can list all the related cells so I can show you how the formula would look.
i prefer sumproduct for this if that's what tyou are trying to achieve.
Given the computer (il)literacy of the people who will be manipulating and entering the data, it would be easier to filter, although I could use that as a fallback option.
This is what I found online, and seems to be correct, but my attempts to modify it resulted in abysmal failure.
just curious, but what are you tracking that is so large?
my largest file (which is pretty damn big) comes nowhere close to how large you said yours was last week.
is the data pulled from somewhere that it would be linked to outside sources?