Need Help on special formula for budget sheet

  • Thread starter Thread starter npereira
  • Start date Start date
N

npereira

Hi all,

Newbie here!

I have a spread sheet that I cumulate rows G7:G16 (dollar amounts) wit
total at G21. Now in H7 to H16 is where I put a "P" or empty t
indicate if the corresponding G cell its payed for or not.

I would like a formula that would only calculate the rows (G7 thru G1
that have a P in the corresponding H column cell.

I'm sure this is possible but don't know how to acheive this. Ca
someone help me?

Thanks for your help
 
Hi,

Sure this is possible! One of Excel's best features!!

try:

=SUMIF(H7:H16,"P",G7:G16)

or another option:

=SUMPRODUCT(--(H7:H16="P"),G7:G16)

Do those help
 
Back
Top