Hi
I would like to sum up a range of numbers if it fulfills two conditions
* It pertains to AUS
* Sum only numbers and ignore #N/A
Would appreciate if you could help with the formula. I can't figure out how SUMIFS can be used for this situation.
Thanks
Bookmarks