SUMIF with multiple conditions

Copper Contributor

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