Help With Nested SumIf / Or
On Friday, June 22, 2012 5:54:57 PM UTC-5, foofoo wrote:
Hello -
I am trying to sum a column based on criteria in 2 other columns, and
I need help with the formula.
I need to sum the contents of cells H4 through H200 if Cells C4
through C200 equal "Special Project", and if Cells D4 through D200
equal "New" or "In Progess". A sample is shown below.
Special Project New 3
Special Project In Progress 2
New In Progress 5
Special Project Deployed 7
The expected result is 5.
Thanks
Worked perfectly! Thanks for your help.
|