Calculate Figures in a column if ajacent column has particular da
 

How do i total number of cells if the row fall within a particular month and
the adjacent column has a "Y" in it. Then Convert this to a 3-d Pie

Then the same as above but if the adjacent column is "Blank" instead of a
"Y" in it.

Calculate Figures in a column if ajacent column has particular da
 

Shaggy wrote:
How do i total number of cells if the row fall within a particular
month and the adjacent column has a "Y" in it. Then Convert this to a
3-d Pie

Then the same as above but if the adjacent column is "Blank" instead
of a "Y" in it.

Hi Shaggy,

I think you could use a SUMPRODUCT function, because with sumproduct you can
have more than 1 condition, while with SUMIF or COUNTIF you have just one
condition.

Check online help for SUMPRODUCT.

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy