SUMIF function?
How would I use the sumif function to calculate only numeric values in a row
that may contain text and numeric characters? |
SUMIF function?
=SUMPRODUCT(--(NOT(ISTEXT(A1:A20))),A1:A20)
be aware, dates get counted as dates are just numbers in Excel. -- HTH RP (remove nothere from the email address if mailing direct) "ej764" wrote in message ... How would I use the sumif function to calculate only numeric values in a row that may contain text and numeric characters? |
SUMIF function?
Hi
One way =SUMPRODUCT(--(ISNUMBER(A1:Z1))) for your numerics =SUMPRODUCT(--(ISTEXT(A1:Z1))) for your text values or if the formula is not in the same row as you are testing, then =SUMPRODUCT(--(ISNUMBER(1:1))) to count all 256 cells Regards Roger Govier ej764 wrote: How would I use the sumif function to calculate only numeric values in a row that may contain text and numeric characters? |
All times are GMT +1. The time now is 08:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com