Hi,
I have a column using a simple IF formula - basically gives either the outcome of a 2 or 4 depending on the letter inputted on another column.
Ideally, I'd like to use the SUM formula on this column, so adding all the 2s and 4s up.
However this doesn't appear to work on the output of the formula. Is there any workaround for this?
Last edited by Shoequeeny; 11-17-2021 at 11:56 AM.
Hello and welcome to the forum.
Yes, but you're really not giving us much to work with.
You should be able to use a SUMIFS() to do this but if you want a more considered answer upload the workbook.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hi
what do you mean by " doesn't work". the SUM function ( like =SUM(a1:a10)) does the job
I suspect your outcomes are text looking like numbers ? If so the cell content is left aligned ( without manual alignment)
Is your If formula something like =IF( condition met,"2","4")
?
You just have to remove the double quotes ( they return text strings) =IF( condition met,2,4)
If not post a sample sheet ( see top of page for how-to).
?
Sure - attached are the two columns in question. As you can see, pretty straightforward - I just want to sum ColB. I've done a workaround of COUNTIF atm and then multiplied as I wasn't getting very far with SUMIF.
Hi, thank you - I've posted a sample. The basic SUM formula doesn't work and removing double quotes makes the formula invalid I'm afraid.
As Pepe suggested you are using literal characters, i.e. "2" & "4" not 2 & 4
Change your formula to
=IF($A3="D",4, IF($A3="S",2))
Then use SUMIF()
Ah great - thank you! I didn't realise it was to remove the quote marks from only the outcome, not the condition. That's sorted it, thank you.
B3=IF($A3="D","4", IF($A3="S","2"))+0
Copy down until last S
after sum number
+0 change text in numbers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks