Search code examples
vlookupsumifslibreoffice-calc

An issue with Vlookup

Example

I want in B11 to sum up all 1s (from CLIENT A) and in C11 the amount of appearance of CLIENT A (in this example four times). Same for CLIENT B in B12 and C12.

Solution

  • Enter formula for B11 as =SUMIF(A$2:A$8,"="&A11,B$2:B$8). Then drag down to fill B12.

    Enter formula for C11 as =COUNTIF(A$2:A$8,"="&A11). Then drag down to fill C12.

    System    Counter All
~~~~~~~~  ~~~~~~~ ~~~
CLIENT A        2   4
CLIENT B        2   3

    For some locales, use ; instead of , as the formula delimiter.

    Documentation: SUMIF and COUNTIF.