Help on Formula

  • Thread starter Thread starter npereira
  • Start date Start date
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
 
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!
 
Try this formula in any empty cell outside the shown
ranges...................

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

Vaya con Dios,
Chuck, CABGx3
 
Back
Top