Similar Posts

(EXCEL)Apply COUNTIF in multiple ranges?

ByLilletyummy

I have four tables on one sheet. In each of the four tables, the attendance of several people is marked with an X for a different calendar week. I want to use a formula to find out how often the person was present. Unfortunately, regular COUNTIF doesn't work. I've already tried =SUM(COUNTIF(INDIRECT({"C3:G3"."K3:O3"."C34:G34"."K34:O34"});"x")). This formula does…

Google Sheets – Rule to transfer numbers from another spreadsheet?

Bysleepwalker1990

Hello, In Google Sheets I would like to create a rule to automatically transfer the numbers from another spreadsheet. Attached are two screenshots: Sheet 2: Here the clicks of customer A are entered every week Sheet 1: Here, I want to use a rule to automatically integrate the average clicks of customer A from Sheet…

Subscribe
Notify of
2 Answers
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
DiDiDi394
DiDiDi394
3 months ago

You can open files for free, but you need the Microsoft 365 subscription to edit them

1