I think this is an IF Function I need???

[arkadd61]

So in my attached spreadsheet, you will see columns D, E, F. My intention is, if I put a value of 1 in any of cell in any one of these columns, I want it two separate calculations to happen at the bottom of the columns. The first calculation I simply want it to sum the total (example D3:D80) however many 1's I enter into that column to give me a total in Column D81. And the same for columns E & F. I know how to do that. The tricky formula is "if I enter a 1 say in D3 I want to take the value of whats in cell G3 and add that to the total sum in cell G82." Does this make sense? I'm also open, to other suggestions to get the same result as far as building the spreadsheet. I just want to know how many total inbound, outbound and appointments there are and the dollar value from column "G" that each of those individual sale represent.

Thank you in advance for your help.

Semisi

[FDibbins]

Hi

It would make it easier to help you if you include some dummy data, as well as a few sample answers. and how you arrived at them?

[arkadd61]

I appreciate that very much. I'll just add some values to the cell of what I envision and any suggestions would be greatly appreciated. Please see the attached updated spreadsheet.

SemisiProspect Tracking 2.xlsx

[FDibbins]

Thank, that helped a lot

for column D, use this, and copy to E...
=SUMIF(D$3:D$80,1,$F$3:$F$80)

for column G, use this and copy to H...
=SUMIF(G$3:G$80,1,$I$3:$I$80)

[arkadd61]

That was perfect!!! Thank you so much for your help.

[FDibbins]

Happy to help

[arkadd61]

Again, I wanted to thank you for you help earlier. I had another factor that came up on this same spread sheet. So if I want to enter a 2, 3, 4, 5, 6, 7, 8, or more, how can we tweak the formula you sent me earlier to accommodate the customer that may want more than one? So if they enter 2 then it would need to multiply against the dollar amount.