Hello all, I was working on the following problem online. The goal was to use sumifs to find the total the amount of active visits that exceeded 10 visits. I got the correct answer using the formula below
=SUMIFS(C41:C45,A41:A45,"active",B41:B45,">=10") This formula works
Answer = 325
=SUMIFS(C41:C45,A41:A45,E40,(B41:B45,>=F40)) This formula does not work
I tried to do this problem with cells instead of text for "active" and "10", but I'm not getting an the answer. E40 and F40 were the cells the word active and the number 10 were located at.
Status Visits Amt active 10
Active 4 100
hold 15 250
active 10 125
active 18 200
hold 9 180
Bookmarks