Formula problem when trying to arrive at a total

**verifier** · 03-13-2012, 01:47 PM

All:

I am having trouble coming up with the proper formula on the attached Excel sheet. Here is what I am trying to do:

I need the Delivered Correctly total in cell I-16 to include the information already in the cell plus the totals from cells I-19, I-20 and I-21. The Delivered Correctly total must include the Pileup (Not Delivered), For Sale (Delivered) and For Sale (Not Delivered). No matter what I try, I receive an error message informing me my formula is incorrect.....I am at a loss.

Any assistance would be greatly appreciated.

**Richard Buttrey** · 03-13-2012, 01:52 PM

Hi,

Other than the fact that you're not including the I19:I21 cells then I can't see why you get an error message

=COUNTIF($A$3:$A$104,H16)+SUM(I19:I21)
works OK for me.

What error are you getting?

**dilipandey** · 03-13-2012, 01:53 PM

Hi verifier,

Basis your description, Formula should be;-

=COUNTIF($A$3:$A$104,H16)+I19+I20+I21

Regards,
DILIPandey

<click on below 'star' if this helps>

**verifier** · 03-13-2012, 02:01 PM

Originally Posted by Richard Buttrey

Hi,

Other than the fact that you're not including the I19:I21 cells then I can't see why you get an error message

=COUNTIF($A$3:$A$104,H16)+SUM(I19:I21)
works OK for me.

What error are you getting?

Richard:

I didn't have the word SUM in there. I added it and it worked!! Thank you very much.