Help on Formula

N

npereira

Hi all,

Newbie here! I think the post goes 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
 
R

rockermm

Instead of creating one simple formula, I create a new column I wit
formula:

=IF(H7="p",G7,0)

Apply this to all the rows in column I, you can sum the results at th
bottom. Hope that helps!
 
C

CLR

Try this formula in any empty cell outside the shown
ranges...................

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

Vaya con Dios,
Chuck, CABGx3
 
Top