Formula

Sue van Niekerk

Hi All, cant get my formula to work - need my bottom table in brown to extract info from top table - so in top table there will be several entries with each of the names already in there - I need bottom table to calculate how many "count Asset" where done in July for "full inspections"

Mark Cronk

Try:

=SUMIFS([count assets]5:[count assets]17, [Inspection type]5:[inspection type]17, "full inspections")

Work?

Mark

Sue van Niekerk

hi gives me a unparseable error

Sue van Niekerk

It worked :-) just had to correct headings to match the formula

Thank you :-)

Mark Cronk

Hi Sue, I had a column name incorrect. Try:

=SUMIFS([count assett]5:[count assett]17, [Inspection type]5:[inspection type]17, "full inspections")

Work now?

Mark

Mark Cronk

Glad you found a solution. Thank you for contributing to the Community.

Mark