Notifications
Clear all
Topic starter
Hi
Here i am confuse to total only numeric data, but here is date also in same column. any body provide formula for summing only numeric data.
Thanks/Saliha
Posted : 03/11/2022 8:55 am
Hi Saliha,
In Excel dates are numbers too. They're stored as date serial numbers, so it's not as simple as identifying which values are dates vs numbers simply by the value itself.
If you have an adjacent column with a criteria, you can use, like you do in the example file in column B, then you can use a SUMIF formula like so:
=SUMIF(B3:B11,"Numeric",C3:C11)
Mynda
Posted : 03/11/2022 7:04 pm
Topic starter
Thanks a lot Mynda got it my answer.
Posted : 04/11/2022 12:47 am