hello,
I need some help creating a sumif statement with an AND statement. I have enclosed a sample file that should answer any questions.
I have an employee that performs 2 job functions. (1=measure, 4=install.)
I have a summary that I want to add up the square footage for each job. So I would like a statement something along these lines:
sumif(a:a = 01smit AND c:c = 1 add up column B)
Thanks in advance.
Bookmarks