I'm trying to take attendance using a SUMIFs formula, but based on data in two columns. For example, I want to total the occurrence of initials "MD" in a range of columns, but only if the adjoining column contains criteria texts "checked in or coverage". So if ac3:ac25 contains "MD", it would only be included in the SUMIFS if ad3:ad25 contains "checked in or coverage". Is this possible, or too complex of a formula?

  • nor ac3:ac25, neither ad3:ad25 are valid ranges. Please, share a test sheet with some data
    – Daniele
    Jun 6 at 8:58


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.