Formula problem when trying to arrive at a total

[verifier]

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]

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]

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]

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.