Good afternoon all, this is my first post, so please be gentle.
I have an excel spreadsheet, where we have 4 different mailings showing (columns B - E). In Column O, I need a formula that adds £20 for each of the columns (B-E) that are populated. So if only 2 of the columns are populated, it will show £40, if one column is populated, it will give me £20, if all 4 columns are populated, it will give me £80.
Hopefully this makes sense,
How aboutFormula:
Please Login or Register to view this content.
how about using
=COUNTA(B6:E6)*20
BUt not sure what you have in O already
=IF(SUM(F6:N6)<125,125,SUM(F6:N6))
do you want to add , 20,40,60,80 to this number
if so
=IF(SUM(F6:N6)<125,125,SUM(F6:N6))+(COUNTA(B6:E6)*20)
you may want to blank out the cell when not used
so and
=IF( A2="", "", IF(SUM(F6:N6)<125,125,SUM(F6:N6))+(COUNTA(B6:E6)*20)
assuming always have a date
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Fluff13 and Wayne, that is perfect, don't know why I didn't think of count in the first place, but yes this has solved my problem, stars, thank you
Glad to help & thanks for the feedback.
you are welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks