Calculate Figures in a column if ajacent column has particular da

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Shaggy said:
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.
Click to expand...

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
 
Back
Top