Answer the question
In order to leave comments, you need to log in
How to write sum formula in google excel?
I am preparing a table with project data and the pivot table should count the number of days for given conditions from another sheet and the sum of days.
Given 4 excel sheets
3 projects + pivot table
In the project table there is a page complexity column with selection options, for example "complex" and "simple", in the pivot table you need to count the number of these pages and how many days they can be done ... is this possible?
Pivot
Table Project Table
Answer the question
In order to leave comments, you need to log in
IMHO, simple formulas COUNTIF and COUNTIFS will help with your task
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question