RE: Use SUM in an array function to count values that match multiple criteria | Message 6 of 6 | TechRepublic

Discussion on:

Use SUM in an array function to count values that match multiple criteria

View entire thread

Message 6 of 6

Next »

1 Vote

+ -

RE: Use SUM in an array function to count values that match multiple criteria

1 - The formula given, =(SUM(IF(D2:D15>=30000,IF(D2:D15 =30000),N(D2:D15 =30000",D2:D15,"50000")

Posted by bobumlas@...

16th Apr 2009