I am having trouble writing a function in excel that will count the number (similar to countifs function) and sum the $ amount (like the sumifs function, but that was not working due to the multiple columns with multiple criteria options in each column).
Example:
Sum Column R, IF
Column AB = 1C1 or 1C2A or 1C2B or 1A1 or 1D AND
Column Z = 128 or 160 or 650 or 125 or 641 AND
Column X = 1 or 2 or 3 or 5 or 6 or 7 or 10 or 12 AND
Columns AN = 005 or 012 AND
Column O = <2011000
Please advise if anyone knows of a function. This is my first post, so please let me know if more detail is required.
Bookmarks