Excel Formula - Works in 1 Cell, Not the Other - Identical!

[Maillme]

Hi there,

I have a formula in a test condition spreadsheet - which is used to count the number of conditions that are still to be run, with low/medium/high priority. I have the same formula(s) for high priority / low priority etc.

This formula works and counts correctly:

=SUM(IF(Conditions!G2:G569="To Be Run",IF(Conditions!H2:H569="Low",1,0),0))

So that tells me how many of my cells on my conditions sheets have "To Be Run" and are of a "Low Priority".

So - I've copied this formula to the cell above to count my medium priorities, as follows:

=SUM(IF(Conditions!G2:G569="To Be Run",IF(Conditions!H2:H569="Medium",1,0),0))

This however displays "0" (and it shouldn't).

Only difference i can see, is when i click on the cell that works, the full formula has parinthesis around it = {} However, when i click in, these disappear.

Please help - spent far too much time scratching my head now! thank you.

Im happy to upload spreadsheet to view somewhere.

Neil

 

[arthurbr]

The braces you have around the formula denote an array formula.Only way of putting them back correctly is to go to the formula bar and do Ctrl+Shift+Enter.
Braces will be added
Each time you edit the formula you will have to do the same
You might also try the following =sumproduct((Conditions!G2:G569="To Be Run")*(Conditions!H2:H569="Low"))