- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel
- 2008 July
- Sumif I Think

Subject: | Sumif I Think |

Posted by: | Paul (Msr…@TPx12.com) |

Date: | Fri, 25 Jul 2008 |

D E G I

p s $2 $2

q t $2 $2

p s $2

r y $2

s z $2 $2

p t $2 $2

I have the following formula in a table which gathers data from the

example above..

=SUMPRODUCT(($D$15:$D$2000="P")*($E$15:$E$2000="S")*($G$15:$G$2000)*($I$15:$I$2000))

The problem is that in column I sometimes there isn't a dollar amount,

so the formula I have multiplies $2 x 0 and comes up with Zero.

Ex: I want to know the total dollar amounts for Items P that

correspond with Items S...answer should be $6

Thanks

- Re: Sumif I Think posted by Rick Rothstein \(MVP - VB\) on Fri, 25 Jul 2008
- Re: Sumif I Think posted by Sandy Mann on Fri, 25 Jul 2008