Forum Discussion
SUMIF with multiple conditions
I'm trying to create a formula that will add together a list of numbers in a column (B) based on the value of another column(A), however I also want to add a condition to divide the number by 2 before it calculates the total if "/" is present in column A.
Hope this makes sense, thanks in advance!!
1 Reply
- Hi Abbie
I'm a little lost, but if you are able to upload a sample spreadsheet of what you are after, maybe it will help? Also we can edit it directly and send it back to you to see.
Cheers
Damien
