Forum Discussion

Copper Contributor

Jun 26, 2021

Using and IF/And to add to an array formula to count

Hi use the following formula to sum Purchase Orders in my file. I would like to add in and if or if and or some other part so that the formula will also count by location which is in column C. The...

Formulas and Functions

JMB17

Bronze Contributor

Jun 28, 2021

Try this. Of course, you could use a cell reference for the department.

=SUM((C2:C121="ALEXIS FARMA INT")/COUNTIFS(A2:A121,A2:A121,C2:C121,C2:C121))

anncshaw

Copper Contributor

Jun 28, 2021

I am trying to do this but I am getting Value# in the cell.
Is it possible to add the count if for the site into this array?
{=SUM(1/(COUNTIF(A2:A121,A2:A121)))}
Thanks
Ann