sumif with three conditions - Please Help!
Posted by itgirl168 on July 29, 2001 6:05 PM
I have a spreadsheet that has two columns. I need to add all instances where the first column has the word "network" and second column equals 1. Currently I have a column for "network", a separate column for "network control", another column for "network problem", and yet another column to combine those totals. Is it possible to combine those instances in ONE? I've tried all day and just can't figure it out.
My current formula reads:
=SUM(IF($E$3:$E$401="Network Control Center",IF($F$3:$F$401=J75,1),0))
network control 1
network control 4