Summing based on a Criteria

Originally Posted by Smee

Afternoon...

Not to sure where to start on this... Attached should be a mini Excel..

As you can see i have 2 main column to fill in.. Days of Errors (basically the turn around to get something fixed) and the Type of Problem (Network or Firewall Based)

i have done a formula to count how many Network issues we have had within the Column..

BUT!!!!

How do i work out how many Total Days i have had an issue.. I.e Firewall i have had 3 insidence at a cost of 10 Days to get repaired..

Hope that makes Sense

Thanks

Lee

Hi, and good morning!!!
Try these in C4 and D4
=SUMIF($B$2:$B$5,C1,$A$2:$A$5) =SUMIF($B$2:$B$5,D1,$A$2:$A$5)