AVERAGE(IF Formula (Excel 2000)

Topic

New Reply

Have checked through some previous posts looking for help with this function when dates are involved, but couldn’t seem to get any of them to work for me. In the attached .xls, Cel J6,I would like to have an Avg of Jumbo_ND based upon the RDate and BOM. I did try:

{=AVERAGE(IF((Tran_Date=BOM),Jumbo_ND)*FDIM))}

This did not seem to work.

Thanks for any assistance that you can provide.

Marie

Reply | Quote

Replies

Is this one OK:

{=AVERAGE(IF((Tran_Date=BOM),Jumbo_ND)*FDIM)}

Reply | Quote

Just the average (not including *FDIM) should come to 54, and I am getting 36? Do you think that this has something to do with the blank cells?

Reply | Quote

Try:
=AVERAGE(IF((Tran_Date=BOM)*ISNUMBER(Jumbo_ND),Jumbo_ND)*FDIM)

This will ignore blanks in Jumbo_ND and not treat them as zeroes.

Steve

Reply | Quote

That was the ticket!

Thanks again!!!

Reply | Quote