I'm trying to SUM without including numbers that have N/A in the column next to them. I know a SUMIF function is what I need however I keep trying it and it keeps not working for me. I'm sure that I'm missing something
I'm trying to SUM without including numbers that have N/A in the column next to them. I know a SUMIF function is what I need however I keep trying it and it keeps not working for me. I'm sure that I'm missing something
Last edited by MitchMitchell; 03-08-2022 at 01:24 AM. Reason: Solved
maybe
Formula:Please Login or Register to view this content.
I'm not an expert, but I'll try
I tried it out and it didn't work. I think we're close, but I think we're missing one key component that I at least can't figure out rn
Due to the firewall protection of the forum, the formula cannot be posted, so please see the attachment
Cell C14 formula
I'm trying to SUM the column next to the percents, not the percents. Sorry for any confusion. I want to sum column B and have my sum formula exclude the numbers that are next to N/A
Try this
=SUMIF( C1:C13, "<>N/A",B1:B13)
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Due to the firewall protection of the forum, the formula cannot be posted, so please see the attachment
Cell C15 OR C16 formula
This was it! Thank you to everyone on this thread for helping me out; I really appreciate it. @wk9128 I can see why you're called an expert I cannot thank you enough. Thanks everyone
@MitchMitchell You're Welcome. Glad to help . Thank You for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks