Need Help on special formula for budget sheet

[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

 

[firefytr]

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

 

[npereira]

Yes thanks ! That helped