2 Conditions + Sum of a colum matching those conditions
Bob,
Thank you so much for your help.. You are a stress saver!! :o)
"Bob Phillips" wrote:
=SUMPRODUCT(--(C2:C200="Windows Desktop"),--(O2:O200="HP Finance"),G2:G200)
Note that SUMPRODUCT doesn't work with complete columns, you have to specify
a range.
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Jeffa" wrote in message
...
Ok.. I've spent the last 2 hours reading this area trying to find a close
enough match to what I am looking for. I know this will be simple.. but
I've
ended up having to post.. I'm sorry :(.
This is what I have..
Col c = windows desktop or windows laptop
Col g = It's monthly $ charge
Col o = Who it is owned by (Finance companies)
I would like to have a breakdown of Desktops laptops with a cost item..
For
example
If col c = "Windows Desktop" & Col o = "HP Finance" Sum(g:g) (what's left
after the 2 conditions are met.
Hope that makes sense.. I'd love some help :)
Regards,
Jeffrey
|