Countif

[will_robbo]

Hi guys,

im using multiple sheets and i need to use complicated criteria...

1) i need to find the cell in the ranges B4:B11 and K4:K11 that is equal to "Red" and then add the cell to the right of it to the overall sum...

i.e. if G5 is "Red" then it will add the number in H5 to the overall sum with multiple sheets...

2) now i need another formula which first finds the cell "Red' again in the same range as in 1)... but now i need it to do an IF statement or something that counts it as 1 if the number of one cell to the right of "Red" is greater than the number in another column.... Very bad explanation...

Basically.. if G5 is "Red" and H5>L5 then count it as "1"... or if K6 is "Red" and L6>H6 then count it as "1"

Very sorry for the bad explanations.. hope you can understand what i want to achieve...


thanks again in advanced

[JBeaucaire]

Maybe a SUMPRODUCT formula..you don't say how far a range to count in, so here it is for G5:G100 -

=SUMPRODUCT(--(G5:G100="red"),--(H5:H100>L5:L100))

[mubashir aziz]

if you are confused with your formula's or explanations then it always good to attached sample file with some sample data and examples ........

[Snkypete]

Just a quick thank you, I did a search and this resolved a data summation I was trying to do for a server list by OS and then by active/retired/planned.