Good Morning,
I have a file that shows text and numbers in the same column. I want to do a sumif formula that will only return totals for those items in the column that are values, not text.
Ex.
Bread $15
123 $11
234 $2
345 $2
I want the sumif to result in $15 no $30 based on the sample table above.
If that is two column of data, and if the numbers in column A are actual numbers, not stored as text, then this should do:
=SUMIF(A:A,"*",B:B)
Everyone who confuses correlation and causation ends up dead.
Try: =SUMIF(A:A,">-10E35",B:B)
Rorya - That worked. Thank you!
What does "*" do? I'm assuming it dictates values somehow.
It's a wildcard meaning any character, but it happens that SUMIF won't include any cell that just contains a number. If the cell is formatted as Text or prefixed with an apostrophe it would be counted even if it contained something that otherwise looks like a number.
So did that formula count all the cells containing text?
Sorry, I am a little slow understanding this morning.
It sums the values in B for any row where column A contains text.
Makes sense.
Thank you
Hi dear
use this array formula
=SUM(IF(ISNUMBER(CriteriaRange),SumRange))
use ctrl+shift+enter
Regular formula:
Formula:
Please Login or Register to view this content.
this will sum values in col B but will ignore cells with text
v A B C D 1 Bread $15 15 2 123 $11 3 234 $2 4 345 $2
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks