I have a similar problem, except I need to count column C if criteria
in Columns A and B are met.
Any ideas?
Thanks,
Steve
Trevor Shuttleworth wrote:
You're welcome.
"DME" <craigjoseathotmaildotcom wrote in message
...
Thank You!
"Trevor Shuttleworth" wrote in message
...
Look at SUMPRODUCT
=SUMPRODUCT((A1:A50=3)*(B1:B50="yes")*(C1:C50))
Regards
Trevor
"DME" <craigjoseathotmaildotcom wrote in message
...
Is there a function similar to SUMIF that would take two
criteria into
consideration? For instance
I want to sum all cells in Column C if Column A =3 and Column B
=Yes.
I know sumif will work for 1 criteria but cannot seem to think
of how
to
make it sum for two.
thanks for the help.
|