Formula Question SUMIF
Its returning a #N/A ?
"Dave" wrote:
Hi, try:
=Sumproduct(--(A3:A3000="East")*(U3:U3000="not cleared")*(Q3:Q3000))
Regards - Dave
"Belinda7237" wrote:
I want to create a subtotal for all items with a status of "not cleared" when
the region is East.
My columns are set up so the Region column is A, my total value column is Q
and my status column is U
The team has helped me a great deal providing me with this formula:
=SUMIF(U3:U3000,"<cleared",Q3:Q3000)
which subtotals cleared items, but now that i have created a summary tab, I
wanted to include the Region variable.
How do I add another variable to this equation?
Thanks!!!
|