Conditional formula?

[y_not]

Hi, I'm trying to find a way to total the number of cells that meet a given criteria.

It works something like this: -

If [A1="Test"] AND [B1 is greater than zero] then [add to the number of cells that meet this condition]

The formula will apply to 350 rows, cell in column A will contain one of six options (all text) and column B will either have no value or will have a numeric value.

I know this can be done but I am currently brain dead! Can anyone advise, please?

Many thanks for all the help in the past.

Tony

[Bondi]

Hi Tony,

Maybe you can use

=SUMPRODUCT((A1:A350="Test")*(B1:B350>0))

This will give you the number of cells that meets the above criteria.

Regards,
Bondi

[y_not]

Thanks Bondi - works a treat