LinkBack URL
About LinkBacks
hi, please help with this..
I'd like to sum the following, ignoring F.O.Cs
7,500.00
2,250.00
F.O.C
=?
and also auto compute rows with F.O.Cs (each in different cells)
QTY---Unit Price---Total
5---------6---------30
2-------F.O.C-----F.O.C
Auto Sum but ignoring FOC (letters)
hi, please help with this..
I'd like to sum the following, ignoring F.O.Cs
7,500.00
2,250.00
F.O.C
=?
and also auto compute rows with F.O.Cs (each in different cells)
QTY---Unit Price---Total
5---------6---------30
2-------F.O.C-----F.O.C
Surely =sum(A1:A4) works perfectly.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Untitled.png
Thanks for the reply Glenn but it appears like this.
Formula is Qty. x Unit Price
I forgot to edit the Total Price it also appears #Value because of the F.O.C
=IF(ISNUMBER(F3),E3*F3,F3)
In G3 (if I have understood the set-up in your screenshot properly - it's always better to upload a workbook).
Last edited by AliGW; 05-27-2014 at 03:55 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Thank you AliGW. It worked.
Here it was before your formula.
Last edited by hunglytummy; 05-27-2014 at 04:04 AM.
No need for the workbook now - just bear it in mind if you come back with any other queries. Glad to have helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks